﻿CREATE TABLE [CAT].[Products]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [Code] VARCHAR(20) NOT NULL, 
    [Name] VARCHAR(50) NOT NULL DEFAULT '', 
    [Description] VARCHAR(200) NOT NULL DEFAULT '', 
    [Price] FLOAT NOT NULL DEFAULT 1, 
	[Dimensions] VARCHAR(20) NOT NULL DEFAULT '', 
    [Active] BIT NOT NULL DEFAULT 1, 
    CONSTRAINT [UK_CAT.Products.Code] UNIQUE(Code),
)

GO
CREATE INDEX [IX_CAT.Products_Name] ON [CAT].[Products] ([Name])

GO
CREATE INDEX [IX_CAT.Products_Code] ON [CAT].[Products] ([Code])